Kimberly Loveless
Kimberly Loveless
Reactions
-
Re: New to Smartsheet - Setting alerts once status has changed
I am glad that it is working for that one. The yes one, as it is currently written, unless the date is exactly 5 days away it wouldn't show. If you want it to show the yes/green for anything 5 days o…1 · -
Re: New to Smartsheet - Setting alerts once status has changed
Ok so first the status is showing 0 or 1 because that is the value used in your formula I would guess the community post you pulled it from was referring to a checkbox column type (where 1 would be c…1 · -
Re: Due In 5 Days or Less Reminder If Not Completed
I am not sure if you are able to do that in the automation. BUT you could add a helper checkbox column, I have done this on a similar solution of mine. What you would do is set a column formula that …1 · -
Re: Date Compare Formula
I think that the formula below should work, or be close to what you need... =IF(OR([Actual Finish Date]@row>[Baseline Finish Date]@row, AND(ISBLANK([Actual Finish Date]),[Baseline Finish Date]@row…1 · -
Re: Questions: Sheet Automation with Multiple Due Dates and Departments
Question 1- you should be able to list all in a single condition Question 2- the automation workflows look at the row level so different dates in other rows won't trip it up Question 3- you will need…1 ·
